/**
 * 
 */
package com.music.service.members.constants;

/**
 * @author asanthan
 * 
 */
public class MemberSQLQueries {
	public static final String INSERT_MEMBER =
		"insert into members(email,creation_date) values " +
		"(?,sysdate)";
	
	public static final String VIEW_MEMBERS = 
		"select playlist_id,playlist_name,creation_date,last_added_song_id"
			+ "from members where created_member_id=? && playlist_id=? && state != ?";
	
	public static final String DELETE_SONG_FROM_MEMBER =
		"delete from playlist_songs_r where playlist_id = ? && song_id = ?";
	
	public static final String DELETE_MEMBER =
		"update members set state = ? where playlist_id =? && created_member_id=?";
	
	public static final String GET_MEMBER_BY_EMAILID =
		"select member_id,member_name,email,birth_date,gender from members where email = ?";
	
	public static final String GET_MEMBER_BY_MEMBER_ID =
		"select member_id,member_name,email,birth_date,gender from members where member_id = ?";

}
